2015-04-22 - 18669 - Spec - Create SA271 Report #CrystalReportDevelopment
SPECIFICATIONS
18669 - Create SA271 Report
Requirement Summary
Need to create new report SA271 similar to SA270 by using Sales Rep as Navigational.
Admin Info
Purpose
|
Need to create new report SA271 similar to SA270 by using Sales Rep as Navigational.
|
Requested By
|
Andrea Beats
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
04/29/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SA271 Global & Regional
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
24
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to create SA271 report similar to SA270 for both Global & Regional regions by making Sales Rep as Navigational & transport the queries to BPQ & BPP.
In Scope:
Need to replace Transnational Sales Rep with Navigational Sales Rep in all the New BEx Queries of SA271 report.
Out of Scope:
Other BEx Queries.
Solution Summary
1. Need to create new BEx Queries similar to SA271 BEx query in BPD.
2. Need to add Sales Rep Navigational in Free Characteristics Pane.
3. Need to maintain required info objects and other query properties as required.
4. Need to check the BEx queries for QA Standards.
5. Need to unit test in BPD and transport it to BPQ for further testing.
6. Notify NEC once it is moved to BPQ and BPP.
7. Need to add the Navigational Sales Group instead of the transactional in SA271 reports.
8. Need to check & follow NEC standards while modifying the report.
BW BEx Queries Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Need to check BEx Queries against standard BEx Query checklist.
|
BEx Queries should pass all BEx Query checklist test cases.
|
2
|
Test the Query Functionality in BPQ.
|
Query Should be succcesfully validated in BPQ.
|
Crystal Reports Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to create new BEx Queries for SA271 similar to SA270 in BPD for both Global & Regional and then transport the Same to BPQ & BPP.
2. Need to add Sales Rep Navigational in Free Characteristics Pane.
3. Maintain required info objects and other query properties as per NEC BEx Query Checklist.
4. Need to check the BEx queries for QA Standards.
5. Need to unit test in BPD and transport it to BPQ for further testing.
6. Notify NEC once it is moved to BPQ and BPP.
7. Need to add the Navigational Sales Group instead of the transnational in SA271 reports.
8. Need to check & follow NEC standards while modifying the report.
Issues
None